Purpose
Keep track of status of krypto portfolio over time, based on transactions combined with current price data.
- Import krypto transaction data from spreadsheet.
- Download latest price data.
- Combine to calculate theoretical profit/loss trends.
- by currency
- overall portfolio
Method
- Log into crypto account.
- John > Statements & Reports > Get latest annual or monthly stmt.
- Retrieve stmt from email. (new format as of 2022, but cols still align)
- Go to spreadsheet in Marengo - check most recent transaction date there.
- Copy/paste new transactions from activity report.
- Copy down formulas in spreadsheet.
Bitcoin
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-05-07
|
BTC-CAD
|
$48,713.25
|
$46,335.12
|
-4.88%
|
Transactions & Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
- Get latest price data.
- Combine with cost data.
- Calculate profit and ROI.
Ethereum
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-05-07
|
ETH-CAD
|
$1,914.50
|
$3,462.65
|
80.86%
|
Transactions & Adjusted Cost Base (Avg Cost)
Cardano
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-05-07
|
ADA-CAD
|
$2.29
|
$1.00
|
-56.34%
|
Transactions & Adjusted Cost Base (Avg Cost)
Polkadot
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-05-07
|
DOT-CAD
|
$34.31
|
$18.21
|
-46.92%
|
Transactions & Adjusted Cost Base (Avg Cost)
Litecoin
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-05-07
|
LTC-CAD
|
$228.96
|
$124.33
|
-45.70%
|
Transactions & Adjusted Cost Base (Avg Cost)
PRICE-COST SMRY

|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-05-07
|
BTC-CAD
|
$48,713.25
|
$46,335.12
|
-4.88%
|
|
2022-05-07
|
ETH-CAD
|
$1,914.50
|
$3,462.65
|
80.86%
|
|
2022-05-07
|
ADA-CAD
|
$2.29
|
$1.00
|
-56.34%
|
|
2022-05-07
|
DOT-CAD
|
$34.31
|
$18.21
|
-46.92%
|
|
2022-05-07
|
LTC-CAD
|
$228.96
|
$124.33
|
-45.70%
|
TOTALS - Returns

|
date
|
currency
|
book_val
|
market_val
|
profit
|
roi
|
|
2022-05-07
|
BTC
|
$3,627
|
$3,450
|
(177)
|
-5%
|
|
2022-05-07
|
ETH
|
$7,676
|
$13,884
|
6,208
|
81%
|
|
2022-05-07
|
ADA
|
$7,330
|
$3,200
|
(4,129)
|
-56%
|
|
2022-05-07
|
DOT
|
$3,465
|
$1,839
|
(1,626)
|
-47%
|
|
2022-05-07
|
LTC
|
$2,305
|
$1,252
|
(1,053)
|
-46%
|
|
date
|
total_invested
|
total_market_val
|
total_profit
|
total_roi
|
|
2022-05-07
|
$24,403
|
\(23,625</span> </td> <td style="text-align:right;"> <span>\)-777
|
-3%
|